<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>BirtComp</title>
    <link rel="StyleSheet" href="css/ScriptingReference.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="ScriptingReference.24.2.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="ScriptingReference.24.4.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h2 class="RH1_Class">Class  <a name="275951">BirtComp</a></h2>
      <p class="b_Body"><a name="275952">The BirtComp class provides functions to compare values, for example, to test if a value is equal to, greater than, or less than another value. All the functions return boolean values. This class is static. The application cannot create instances of the class.</a></p>
      <h3 class="RH2_Method"><a name="275953">BirtComp.anyOf</a></h3>
      <p class="b_Body"><a name="275954">This function compares one or more values to the contents of a field,.</a></p>
      <p class="N_sb_ScanBold"><a name="275955">Syntax</a></p>
      <div class="rs_RSyntax"><a name="275956">boolean BirtComp.anyOf( source, target1, ..., targetN )</a></div>
      <p class="N_sb_ScanBold"><a name="275957">Parameters</a></p>
      <p class="RParameter"><a name="275958">source</a></p>
      <p class="bn_BodyNoLead"><a name="275959">A field with contents to use for comparison.</a></p>
      <p class="RParameter"><a name="279956">target</a></p>
      <p class="bn_BodyNoLead"><a name="279960">The value or values to find in source.</a></p>
      <p class="N_sb_ScanBold"><a name="275960">Returns</a></p>
      <p class="b_Body"><a name="275961">Boolean. True if a target value matches a value in source; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="275962">Examples</a></p>
      <p class="b_Body"><a name="275963">The following example tests if Canada, Mexico, or USA are values in the Country field. If any one of the countries is in the field, the function returns true.</a></p>
      <div class="cf_CodeFirst"><a name="275964">BirtComp.anyOf(dataSetRow["Country"], "Canada", "Mexico", "USA")</a></div>
      <p class="b_Body"><a name="275965">The following example tests if Jan 15, 2009 or Jan 31, 2009 are values in the payDate field:</a></p>
      <div class="cf_CodeFirst"><a name="275966">BirtComp.anyOf(dataSetRow["payDate"], "2009-01-15", "2009-01-31")</a></div>
      <p class="b_Body"><a name="357420">The following example tests if two specific product codes are values in the productCode field. If either value appears in the field, the string Obsolete is displayed; otherwise the productCode value is displayed as it appears in the field.</a></p>
      <div class="cf_CodeFirst"><a name="357493">if (BirtComp.anyOf(dataSetRow["PRODUCTCODE"], "S18_1749", "S18_2248" )){</a></div>
      <div class="co_Code"><a name="357494">&nbsp;&nbsp;displayString = "Obsolete"</a></div>
      <div class="co_Code"><a name="357495">}else{</a></div>
      <div class="co_Code"><a name="357496">&nbsp;&nbsp;dataSetRow["PRODUCTCODE"]</a></div>
      <div class="co_Code"><a name="357421">}</a></div>
      <h3 class="RH2_Method"><a name="357427">BirtComp.between</a></h3>
      <p class="b_Body"><a name="280060">This function tests if a value is between two specified values.</a></p>
      <p class="N_sb_ScanBold"><a name="280061">Syntax</a></p>
      <div class="rs_RSyntax"><a name="280062">boolean BirtComp.between( source, target1, target2 )</a></div>
      <p class="N_sb_ScanBold"><a name="280063">Parameters</a></p>
      <p class="RParameter"><a name="280064">source</a></p>
      <p class="bn_BodyNoLead"><a name="280065">The value to test.</a></p>
      <p class="RParameter"><a name="280066">target1</a></p>
      <p class="bn_BodyNoLead"><a name="280067">The first value in the range of values to compare to.</a></p>
      <p class="RParameter"><a name="280458">target2</a></p>
      <p class="bn_BodyNoLead"><a name="280462">The second value in the range of values to compare to.</a></p>
      <p class="N_sb_ScanBold"><a name="280068">Returns</a></p>
      <p class="b_Body"><a name="280069">True if the source value is between the target1 and target values; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="280070">Examples</a></p>
      <p class="b_Body"><a name="280071">The following expressions test field values to see if they are within a specified range of values:</a></p>
      <div class="cf_CodeFirst"><a name="280072">BirtComp.between( row["SalesTotal"], 10000, 20000 )</a></div>
      <div class="co_Code"><a name="280074">BirtComp.between( row["CustomerName"], "A", "M" )</a></div>
      <div class="co_Code"><a name="280486">BirtComp.between( row["OrderDate"], "2009-01-01", "2009-01-31" )</a></div>
      <p class="b_Body"><a name="280075">The following example calculates shipment dates. If an OrderDate value is in December 2008 (between 12/01/08 and 12/31/08), add 5 days to the OrderDate value. If an OrderDate value is in a month other than December, add 3 days to the OrderDate value.</a></p>
      <div class="cf_CodeFirst"><a name="280076">if (BirtComp.between(row["OrderDate"], "2008-12-01", "2008-12-31" )){</a></div>
      <div class="co_Code"><a name="280077">&nbsp;&nbsp;shipDate = BirtDateTime.addDay( row["OrderDate"], 5 )</a></div>
      <div class="co_Code"><a name="280078">&nbsp;&nbsp;}</a></div>
      <div class="co_Code"><a name="280079">else{</a></div>
      <div class="co_Code"><a name="280080">&nbsp;&nbsp;ShipDate = BirtDateTime.addDay( row["OrderDate"], 3 )</a></div>
      <div class="co_Code"><a name="280081">&nbsp;&nbsp;}</a></div>
      <h3 class="RH2_Method"><a name="287732">BirtComp.compareString</a></h3>
      <p class="b_Body"><a name="287733">This function tests if a string value matches another string value, given specified conditions.</a></p>
      <p class="N_sb_ScanBold"><a name="287734">Syntax</a></p>
      <div class="rs_RSyntax"><a name="287735">boolean BirtComp.compareString( source1, source2, ignoreCase, trim )</a></div>
      <p class="N_sb_ScanBold"><a name="287736">Parameters</a></p>
      <p class="RParameter"><a name="287737">source1</a></p>
      <p class="bn_BodyNoLead"><a name="287738">The first string value to use in the comparison.</a></p>
      <p class="RParameter"><a name="288180">source2</a></p>
      <p class="bn_BodyNoLead"><a name="288184">The second string value to use in the comparison.</a></p>
      <p class="RParameter"><a name="287739">ignoreCase</a></p>
      <p class="bn_BodyNoLead"><a name="288343">Specify true to perform a case-insensitive comparison. Specify false to perform a case-sensitive comparison.</a></p>
      <p class="RParameter"><a name="288346">trim</a></p>
      <p class="bn_BodyNoLead"><a name="288350">Specify true to remove any leading or trailing blanks before comparing the two values. Blanks in the middle of a string are not removed. Specify false if you want the comparison to include leading or trailing blanks. </a></p>
      <p class="N_sb_ScanBold"><a name="287750">Returns</a></p>
      <p class="b_Body"><a name="287751">True if the source1 value matches the source2 value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="287752">Examples</a></p>
      <p class="b_Body"><a name="287755">The following expressions compare strings with different conditions specified:</a></p>
      <div class="cf_CodeFirst"><a name="287756">BirtComp.compareString( "Jackson", "Jackson", false, false ) // returns true</a></div>
      <div class="co_Code"><a name="292200">BirtComp.compareString( "Jackson", "jackson", false, true ) // returns false</a></div>
      <div class="co_Code"><a name="292628">BirtComp.compareString( "Jackson", "jackson", true, false ) // returns true</a></div>
      <div class="co_Code"><a name="292584">BirtComp.compareString( "Jackson ", "jackson", true, false ) // returns false</a></div>
      <div class="co_Code"><a name="292609">BirtComp.compareString( "Jackson ", "jackson", true, true ) // returns true</a></div>
      <h3 class="RH2_Method"><a name="280965">BirtComp.equalTo</a></h3>
      <p class="b_Body"><a name="280966">This function tests if a value is equal to another value.</a></p>
      <p class="N_sb_ScanBold"><a name="280967">Syntax</a></p>
      <div class="rs_RSyntax"><a name="280968">boolean BirtComp.equalTo( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="280969">Parameters</a></p>
      <p class="RParameter"><a name="280970">source</a></p>
      <p class="bn_BodyNoLead"><a name="280971">The first value to use in the comparison.</a></p>
      <p class="RParameter"><a name="280972">target</a></p>
      <p class="bn_BodyNoLead"><a name="280973">The second value to use in the comparison.</a></p>
      <p class="N_sb_ScanBold"><a name="280976">Returns</a></p>
      <p class="b_Body"><a name="280977">True if the source value is equal to the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="280978">Examples</a></p>
      <p class="b_Body"><a name="280979">The following expressions test field values to see if they are equal to specified values:</a></p>
      <div class="cf_CodeFirst"><a name="280980">BirtComp.equalTo( row["SalesTotal"], 10000 )</a></div>
      <div class="co_Code"><a name="280981">BirtComp.equalTo( row["Country"], "France" )</a></div>
      <div class="co_Code"><a name="280982">BirtComp.equalTo( row["OrderDate"], "2009-02-15" )</a></div>
      <h3 class="RH2_Method"><a name="285949">BirtComp.greaterOrEqual</a></h3>
      <p class="b_Body"><a name="285950">This function tests if a value is greater than or equal to another value.</a></p>
      <p class="N_sb_ScanBold"><a name="285951">Syntax</a></p>
      <div class="rs_RSyntax"><a name="285952">boolean BirtComp.greaterOrEqual( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="285953">Parameters</a></p>
      <p class="RParameter"><a name="285954">source</a></p>
      <p class="bn_BodyNoLead"><a name="285955">The first value to use in the comparison.</a></p>
      <p class="RParameter"><a name="285956">target</a></p>
      <p class="bn_BodyNoLead"><a name="285957">The second value to use in the comparison.</a></p>
      <p class="N_sb_ScanBold"><a name="285958">Returns</a></p>
      <p class="b_Body"><a name="285959">True if the source value is greater than or equal to the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="285960">Examples</a></p>
      <p class="b_Body"><a name="285961">The following expressions test field values to see if they are greater than or equal to specified values:</a></p>
      <div class="cf_CodeFirst"><a name="285962">BirtComp.greaterOrEqual( row["SalesTotal"], 10000 )</a></div>
      <div class="co_Code"><a name="285963">BirtComp.greaterOrEqual( row["ProductCode"], "S50_4000" )</a></div>
      <div class="co_Code"><a name="285964">BirtComp.greaterOrEqual( row["OrderDate"], "2009-02-15" )</a></div>
      <h3 class="RH2_Method"><a name="286072">BirtComp.greaterThan</a></h3>
      <p class="b_Body"><a name="286073">This function tests if a value is greater than another value.</a></p>
      <p class="N_sb_ScanBold"><a name="286074">Syntax</a></p>
      <div class="rs_RSyntax"><a name="286075">boolean BirtComp.greaterThan( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="286076">Parameters</a></p>
      <p class="RParameter"><a name="286077">source</a></p>
      <p class="bn_BodyNoLead"><a name="286078">The first value to use in the comparison.</a></p>
      <p class="RParameter"><a name="286079">target</a></p>
      <p class="bn_BodyNoLead"><a name="286080">The second value to use in the comparison.</a></p>
      <p class="N_sb_ScanBold"><a name="286081">Returns</a></p>
      <p class="b_Body"><a name="286082">True if the source value is greater than the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="286083">Examples</a></p>
      <p class="b_Body"><a name="286084">The following expressions test field values to see if they are greater than specified values:</a></p>
      <div class="cf_CodeFirst"><a name="286085">BirtComp.greaterThan( row["SalesTotal"], 10000 )</a></div>
      <div class="co_Code"><a name="286086">BirtComp.greaterThan( row["CustomerName"], "M" )</a></div>
      <div class="co_Code"><a name="286087">BirtComp.greaterThan( row["OrderDate"], "2009-02-15" )</a></div>
      <h3 class="RH2_Method"><a name="286109">BirtComp.lessOrEqual</a></h3>
      <p class="b_Body"><a name="286110">This function tests if a value is less than or equal to another value.</a></p>
      <p class="N_sb_ScanBold"><a name="286111">Syntax</a></p>
      <div class="rs_RSyntax"><a name="286112">boolean BirtComp.lessOrEqual( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="286113">Parameters</a></p>
      <p class="RParameter"><a name="286114">source</a></p>
      <p class="bn_BodyNoLead"><a name="286115">The first value to use in the comparison.</a></p>
      <p class="RParameter"><a name="286116">target</a></p>
      <p class="bn_BodyNoLead"><a name="286117">The second value to use in the comparison.</a></p>
      <p class="N_sb_ScanBold"><a name="286118">Returns</a></p>
      <p class="b_Body"><a name="286119">True if the source value is less than or equal to the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="286120">Examples</a></p>
      <p class="b_Body"><a name="286121">The following expressions test field values to see if they are less than or equal to specified values:</a></p>
      <div class="cf_CodeFirst"><a name="286122">BirtComp.lessOrEqual( row["SalesTotal"], 10000 )</a></div>
      <div class="co_Code"><a name="286123">BirtComp.lessOrEqual( row["ProductCode"], "S18_4000" )</a></div>
      <div class="co_Code"><a name="286124">BirtComp.lessOrEqual( row["OrderDate"], "2009-02-15" )</a></div>
      <h3 class="RH2_Method"><a name="285537">BirtComp.lessThan</a></h3>
      <p class="b_Body"><a name="285538">This function tests if a value is less than another value.</a></p>
      <p class="N_sb_ScanBold"><a name="285539">Syntax</a></p>
      <div class="rs_RSyntax"><a name="285540">boolean BirtComp.lessThan( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="285541">Parameters</a></p>
      <p class="RParameter"><a name="285542">source</a></p>
      <p class="bn_BodyNoLead"><a name="285543">The first value to use in the comparison.</a></p>
      <p class="RParameter"><a name="285544">target</a></p>
      <p class="bn_BodyNoLead"><a name="285545">The second value to use in the comparison.</a></p>
      <p class="N_sb_ScanBold"><a name="285546">Returns</a></p>
      <p class="b_Body"><a name="285547">True if the source value is less than the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="285548">Examples</a></p>
      <p class="b_Body"><a name="285549">The following expressions test field values to see if they are less than specified values:</a></p>
      <div class="cf_CodeFirst"><a name="285550">BirtComp.lessThan( row["SalesTotal"], 10000 )</a></div>
      <div class="co_Code"><a name="285551">BirtComp.lessThan( row["CustomerName"], "M" )</a></div>
      <div class="co_Code"><a name="285552">BirtComp.lessThan( row["OrderDate"], "2009-02-15" )</a></div>
      <h3 class="RH2_Method"><a name="286184">BirtComp.like</a></h3>
      <p class="b_Body"><a name="286185">This function tests if a string value matches a pattern. The pattern must use SQL pattern-matching syntax.</a></p>
      <p class="N_sb_ScanBold"><a name="286186">Syntax</a></p>
      <div class="rs_RSyntax"><a name="286187">boolean BirtComp.like( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="286188">Parameters</a></p>
      <p class="RParameter"><a name="286189">source</a></p>
      <p class="bn_BodyNoLead"><a name="286190">The string value to evaluate.</a></p>
      <p class="RParameter"><a name="286191">target</a></p>
      <p class="bn_BodyNoLead"><a name="286192">The string pattern to match. You must enclose the pattern in double quotation marks (" "). Use the correct case when typing the characters that you want to match. You can use the following special character in a pattern:</a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="286797">A percent character (%) matches zero or more characters. For example, %ace% matches any string value that contains the substring ace, such as Facebook and MySpace. It does not match Ace Corporation because this string contains a capital A, and not the lowercase a.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="286830">An underscore character (_) that matches exactly one character. For example, t_n matches tan, ten, tin, and ton. It does not match teen or tn.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="b_Body"><a name="286834">To match a literal percent (%) or underscore (_) character, precede those characters with two backslash (\\) characters. For example, to match S_10, use the following pattern:</a></p>
      <div class="cf_CodeFirst"><a name="286838">S\\_10</a></div>
      <p class="b_Body"><a name="286842">To match 50%, use the following pattern:</a></p>
      <div class="cf_CodeFirst"><a name="286846">50\\%</a></div>
      <p class="N_sb_ScanBold"><a name="286193">Returns</a></p>
      <p class="b_Body"><a name="286194">True if the source value matches the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="286195">Examples</a></p>
      <p class="b_Body"><a name="286196">The following example returns true for values in the productCode field that start with S18:</a></p>
      <div class="cf_CodeFirst"><a name="286197">BirtComp.like( row["productCode"], "S18%" )</a></div>
      <p class="b_Body"><a name="286720">The following example returns true for productName values that contain the substring Ford preceded by a single character:</a></p>
      <div class="cf_CodeFirst"><a name="286762">BirtComp.like( row["productName"], "_Ford%" )</a></div>
      <h3 class="RH2_Method"><a name="287271">BirtComp.match</a></h3>
      <p class="b_Body"><a name="287272">This function tests if a string value matches a pattern. The pattern must use JavaScript regular expression syntax.</a></p>
      <p class="N_sb_ScanBold"><a name="287273">Syntax</a></p>
      <div class="rs_RSyntax"><a name="287274">boolean BirtComp.match( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="287275">Parameters</a></p>
      <p class="RParameter"><a name="287276">source</a></p>
      <p class="bn_BodyNoLead"><a name="287277">The string value to evaluate.</a></p>
      <p class="RParameter"><a name="287278">target</a></p>
      <p class="bn_BodyNoLead"><a name="287279">The string pattern to match. In JavaScript regular expression syntax, you specify a pattern within a pair of forward slash (/) characters. You can use any special character supported by JavaScript regular expressions, such as the following:</a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="287280">A question mark (?) matches zero or one occurrence of the character previous to it. For example, /te?n/ matches tn, ten, and often. It does not match teen or intern.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="287281">An asterisk (*) matches zero or any number of occurrences of the character previous to it. For example, /te*n/ matches tn, ten, often, and teen. It does not match intern.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="287714">A period (.) matches any character. For example, /te.*/ matches ten, often, teen, intern.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="287724">A caret (^) specifies that the substring to look for is at the beginning of a string. For example, /^ten/ matches ten, tennis, and tense. It does not match often or pretend.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="287725">An i character specifies a case-insensitive search. For example, /smith/i matches Smith, blacksmith, and Smithsonian.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="b_Body"><a name="287282">To match a special character literally, precede the special character with a backslash (\) character. For example, to match S*10, use the following pattern:</a></p>
      <div class="cf_CodeFirst"><a name="287283">/S\*10/</a></div>
      <p class="N_sb_ScanBold"><a name="287286">Returns</a></p>
      <p class="b_Body"><a name="287287">True if the source value matches the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="287288">Examples</a></p>
      <p class="b_Body"><a name="287289">The following example returns true for values in the productCode field that start with S18:</a></p>
      <div class="cf_CodeFirst"><a name="287290">BirtComp.match( row["productCode"], /^S18/ )</a></div>
      <p class="b_Body"><a name="287291">The following example returns true for productName values that contain the substring Ford:</a></p>
      <div class="cf_CodeFirst"><a name="287292">BirtComp.match( row["productName"], /Ford/ )</a></div>
      <h3 class="RH2_Method"><a name="280508">BirtComp.notBetween</a></h3>
      <p class="b_Body"><a name="280509">This function tests if a value is not between two specified values.</a></p>
      <p class="N_sb_ScanBold"><a name="280510">Syntax</a></p>
      <div class="rs_RSyntax"><a name="280511">boolean BirtComp.notBetween( source, target1, target2 )</a></div>
      <p class="N_sb_ScanBold"><a name="280512">Parameters</a></p>
      <p class="RParameter"><a name="280513">source</a></p>
      <p class="bn_BodyNoLead"><a name="280514">The value to test.</a></p>
      <p class="RParameter"><a name="280515">target1</a></p>
      <p class="bn_BodyNoLead"><a name="280516">The first value in the range of values to compare to.</a></p>
      <p class="RParameter"><a name="280517">target2</a></p>
      <p class="bn_BodyNoLead"><a name="280518">The second value in the range of values to compare to.</a></p>
      <p class="N_sb_ScanBold"><a name="280519">Returns</a></p>
      <p class="b_Body"><a name="280520">True if the source value is not between the target1 and target values; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="280521">Examples</a></p>
      <p class="b_Body"><a name="280522">The following expressions test field values to see if they are outside a specified range of values:</a></p>
      <div class="cf_CodeFirst"><a name="280523">BirtComp.notBetween( row["SalesTotal"], 10000, 20000 )</a></div>
      <div class="co_Code"><a name="280524">BirtComp.notBetween( row["CustomerName"], "A", "M" )</a></div>
      <div class="co_Code"><a name="280525">BirtComp.notBetween( row["OrderDate"], "2009-01-01", "2009-01-31" )</a></div>
      <p class="b_Body"><a name="280526">The following example calculates shipment dates. If an OrderDate value is not in December 2008 (not between 12/01/08 and 12/31/08), add 3 days to the OrderDate value. If an OrderDate value is in December, add 5days to the OrderDate value.</a></p>
      <div class="cf_CodeFirst"><a name="280527">if (BirtComp.notBetween(row["OrderDate"], "2008-12-01", "2008-12-31" )){</a></div>
      <div class="co_Code"><a name="280528">&nbsp;&nbsp;shipDate = BirtDateTime.addDay( row["OrderDate"], 3 )</a></div>
      <div class="co_Code"><a name="280529">&nbsp;&nbsp;}</a></div>
      <div class="co_Code"><a name="280530">else{</a></div>
      <div class="co_Code"><a name="280531">&nbsp;&nbsp;ShipDate = BirtDateTime.addDay( row["OrderDate"], 5 )</a></div>
      <div class="co_Code"><a name="280532">&nbsp;&nbsp;}</a></div>
      <h3 class="RH2_Method"><a name="285068">BirtComp.notEqual</a></h3>
      <p class="b_Body"><a name="285069">This function tests if a value is not equal to another value.</a></p>
      <p class="N_sb_ScanBold"><a name="285070">Syntax</a></p>
      <div class="rs_RSyntax"><a name="285071">boolean BirtComp.notEqual( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="285072">Parameters</a></p>
      <p class="RParameter"><a name="285073">source</a></p>
      <p class="bn_BodyNoLead"><a name="285074">The first value to use in the comparison.</a></p>
      <p class="RParameter"><a name="285075">target</a></p>
      <p class="bn_BodyNoLead"><a name="285076">The second value to use in the comparison.</a></p>
      <p class="N_sb_ScanBold"><a name="285077">Returns</a></p>
      <p class="b_Body"><a name="285078">True if the source value is not equal to the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="285079">Examples</a></p>
      <p class="b_Body"><a name="285080">The following expressions test field values to see if they are not equal to specified values:</a></p>
      <div class="cf_CodeFirst"><a name="285081">BirtComp.notEqual( row["SalesTotal"], 10000 )</a></div>
      <div class="co_Code"><a name="285082">BirtComp.notEqual( row["Country"], "France" )</a></div>
      <div class="co_Code"><a name="285083">BirtComp.notEqual( row["OrderDate"], "2009-02-15" )</a></div>
      <h3 class="RH2_Method"><a name="286853">BirtComp.notLike</a></h3>
      <p class="b_Body"><a name="286854">This function tests if a string value does not match a pattern. The pattern must use SQL pattern-matching syntax.</a></p>
      <p class="N_sb_ScanBold"><a name="286855">Syntax</a></p>
      <div class="rs_RSyntax"><a name="286856">boolean BirtComp.notLike( source, target )</a></div>
      <p class="N_sb_ScanBold"><a name="286857">Parameters</a></p>
      <p class="RParameter"><a name="286858">source</a></p>
      <p class="bn_BodyNoLead"><a name="286859">The string value to evaluate.</a></p>
      <p class="RParameter"><a name="286860">target</a></p>
      <p class="bn_BodyNoLead"><a name="286861">The string pattern to compare to. You must enclose the pattern in double quotation marks (" "). Use the correct case when typing the characters that you want to match. You can use the following special character in a pattern:</a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="286862">A percent character (%) matches zero or more characters. For example, %ace% matches any string value that contains the substring ace, such as Facebook and MySpace. It does not match Ace Corporation because this string contains a capital A, and not the lowercase a.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="286863">An underscore character (_) that matches exactly one character. For example, t_n matches tan, ten, tin, and ton. It does not match teen or tn.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="b_Body"><a name="286864">To match a literal percent (%) or underscore (_) character, precede those characters with two backslash (\\) characters. For example, to match S_10, use the following pattern:</a></p>
      <div class="cf_CodeFirst"><a name="286865">S\\_10</a></div>
      <p class="b_Body"><a name="286866">To match 50%, use the following pattern:</a></p>
      <div class="cf_CodeFirst"><a name="286867">50\\%</a></div>
      <p class="N_sb_ScanBold"><a name="286868">Returns</a></p>
      <p class="b_Body"><a name="286869">True if the source value does not match the target value; returns false otherwise.</a></p>
      <p class="N_sb_ScanBold"><a name="286870">Examples</a></p>
      <p class="b_Body"><a name="286871">The following example returns false for values in the productCode field that start with S18:</a></p>
      <div class="cf_CodeFirst"><a name="286872">BirtComp.notLike( row["productCode"], "S18%" )</a></div>
      <p class="b_Body"><a name="286873">The following example returns false for productName values that contain the substring Ford preceded by a single character:</a></p>
      <div class="cf_CodeFirst"><a name="286874">BirtComp.notLike( row["productName"], "_Ford%" )</a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>